<?php 
$this->E_D("DROP TABLE IF EXISTS `db_cms_product`;");
$this->E_C("CREATE TABLE `db_cms_product` (
  `id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
  `catid` smallint(5) unsigned NOT NULL DEFAULT '0',
  `modelid` smallint(5) unsigned NOT NULL DEFAULT '0',
  `title` varchar(255) DEFAULT '',
  `thumb` varchar(255) DEFAULT '',
  `link` varchar(255) DEFAULT NULL,
  `titleurl` varchar(255) NOT NULL DEFAULT '',
  `newstime` int(11) NOT NULL DEFAULT '0',
  `pagetitle` varchar(255) NOT NULL DEFAULT '',
  `keywords` varchar(255) NOT NULL DEFAULT '',
  `description` text NOT NULL,
  `pubid` bigint(15) unsigned NOT NULL DEFAULT '0',
  `sort` int(11) unsigned NOT NULL DEFAULT '0',
  `userid` int(11) unsigned NOT NULL DEFAULT '0',
  `username` char(20) NOT NULL DEFAULT '',
  `addtime` int(10) unsigned NOT NULL DEFAULT '0',
  `editortime` int(10) unsigned NOT NULL DEFAULT '0',
  `is_good` int(11) NOT NULL DEFAULT '0' COMMENT '推荐',
  `is_top` int(11) NOT NULL DEFAULT '0' COMMENT '置顶',
  `views` int(11) NOT NULL DEFAULT '0' COMMENT '点击总数',
  `goods` int(11) NOT NULL DEFAULT '0' COMMENT '点赞数',
  `favs` int(11) NOT NULL DEFAULT '0' COMMENT '收藏数',
  `comments` int(11) NOT NULL DEFAULT '0' COMMENT '评论数',
  `viewtemp` int(11) NOT NULL DEFAULT '0' COMMENT '单独内容模板',
  `thumb2` varchar(255) DEFAULT '',
  PRIMARY KEY (`id`),
  KEY `catid` (`catid`),
  KEY `sort` (`sort`)
) ENGINE=InnoDB AUTO_INCREMENT=56 DEFAULT CHARSET=utf8 COMMENT='产品数据表'");
$this->E_D("replace into `db_cms_product` values('48','15','32','JijinShop Pro','',NULL,'/product/JijinShop.html','1621938625','','','','16219386256813','0','1','admin','1622008805','1622008805','0','0','4','0','0','0','0','');");
$this->E_D("replace into `db_cms_product` values('49','15','32','xxx','','','','1622011197','','','','16220111974938','0','1','admin','1622012879','1622012879','0','0','0','0','0','0','0','');");
$this->E_D("replace into `db_cms_product` values('50','104','50','Climate Control Technologies','/upload/image/20211101/a3f11a531906cf2474bb1e385c871e2d.png','','','1635761095','','','Bring the optimal climate to pigs using intelligent remote monitoring, ensure the ambient temperature, humidity, ammonia level, etc are up to standard','16357610956484','0','1','admin','1637742561','1637742561','0','0','2','0','0','0','0','/upload/image/20211101/7e1411c738e6182b6ba7b98ef35ae4a8.png');");
$this->E_D("replace into `db_cms_product` values('51','104','50','Feed line control technology','/upload/image/20211101/95d50f6563e75001ba8763ca5fe93822.png','','','1635761121','','','Each house''s feed consumption tracking and management can be done automatically','16357611211642','0','1','admin','1637742542','1637742542','0','0','0','0','0','0','0','/upload/image/20211101/c6f3515ac2d1097137eadf73ad47a5f0.png');");
$this->E_D("replace into `db_cms_product` values('52','104','50','Feed Intake Growth Recorder (FIGR)','/upload/image/20211101/5f5608e832f71a84a64f0d707b2f5b85.png','','','1635761156','','','Accurately collect data in real-time, monitor the entire growth cycle, and manage the farm with the help of reliable, intelligent computing
','16357611567846','0','1','admin','1637742521','1637742521','0','0','2','0','0','0','0','/upload/image/20211101/0e9bb6e12ace358f3a1beb562463dd72.png');");
$this->E_D("replace into `db_cms_product` values('53','104','50','Growth and Marketing Sorting System (GMS）','/upload/image/20211101/d615cfa5b266537034aefe1c10e7abdd.png','','','1635761179','','','Record the number of times and weight each pig when they passes through the system, closely monitor their health and accurately predict the best market date','16357611795350','0','1','admin','1637742504','1637742504','0','0','1','0','0','0','0','/upload/image/20211101/0224fb7a3771f802fafdd09f269d9b63.png');");
$this->E_D("replace into `db_cms_product` values('54','104','50','Electronic Sow Feeding System (ESF)','/upload/image/20211101/2295f6fa18742ca73df54304a1430638.png','','','1635761199','','','Record all the sows'' production data, closely monitor their health and conditons','16357611998285','0','1','admin','1637742469','1637742469','0','0','0','0','0','0','0','/upload/image/20211101/223e141d919c638b02fd26e15bc38991.png');");
$this->E_D("replace into `db_cms_product` values('55','104','50','Electric Heating Pad ','/upload/image/20211101/2b277471534632d661a2b1aed9a622d3.png','','','1635761233','','','Intelligent temperature control, energy efficient and increase piglets'' surival rate','16357612339064','0','1','admin','1637742444','1637742444','0','0','0','0','0','0','0','/upload/image/20211101/79599616ea045d137b69dd762019a58e.png');");

 ?>